Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
AddressID (FK)(PK) | A unique system allocated identifier for the Address. | ID_ADS | Identity | integer | Address(LO_ADS) |
EffectiveDateTime (PK) | The date & time from which the nominated GeoPhysicalLocation uses the nominated Address. | TS_EF | EffectiveDateTime | datetime | |
GeographicLocationID (FK)(PK) | Token ID for a GeographicLocation | ID_GEO_LCN | Identity | integer | GeophysicalLocation(CO_GEO_LCN) |
ExpirationDateTime | The date & time after which the nominated GeoPhysicalLocation no longer uses the nominated Address. | TS_EP | ExpirationDateTime | datetime | |